2014-03-05 - 11721 - Enhancement - Add country in the Retail cube #SalesDistribution
ENHANCEMENT
11721 - Add Country in the Retail Cube
Requirement Summary
Need to write logic to populate infoobject 0COUNTRY based on Profit Centers in retail infocube.
Admin Info
Purpose
|
To add logic to Country in the Retail cube based on Profit Center
|
Requested By
|
Mark Harris
|
Spec Created By
|
Chandramouli K
|
Spec Created Date
|
03/05/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZRETAIL
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
1. Need to write logic to populate infoobject 0COUNTRY based on Profit Centers in retail infocube.
2. Based on the Following table we need to write the logic for populating 0COUNTRY in retail infocube.
Profit Centers
|
Store
|
Country
|
0010/PC3300
|
London
|
GB
|
0010/PC3310
|
Birmingham
|
GB
|
0010/PC3340
|
Berlin
|
DE
|
0010/PC3360
|
GMBH Retail Frankfurt
|
DE
|
0010/PC3302
|
Box Park
|
GB
|
0010/PC3304
|
Westfield
|
GB
|
9998/JPNT
|
Tokyo
|
JP
|
0010/PC3315
|
UK Web
|
GB
|
9999/JPNW
|
JAPAN WEB
|
JP
|
3. Need to collect the objects into the transport request and notify the client.
Solution Summary
1. Need to map the infoobject 0COUNTRY with Profit center in the source.
2. Need to write logic to populate country for each record based on profit centers.
3. Need to collect all the changes into the transport request.
4. Unit test the changes in development to confirm the logic.
5. Transport the changes to Quality system for further testing.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if 0COUNTRY is populated correctly as per logic based on Profit Centers.
|
0COUNTRY should be populated correctly as per logic based on Profit Centers.
|
2
|
Check whether all the changes are collected into the Transport Request.
|
All the changes must be collected into the Transport Request.
|
3
|
Check if the logic is coded in routine as per the coding standards of NEC.
|
Code Logic should comply with the NEC coding standards.
|
Solution Details
1. Need to map the infoobject 0COUNTRY with Profit center in the source datasource.
2. Change the rule type to routine for 0COUNTRY & write logic to populate country for each record based on profit centers.
3. Collect the changes into the transport request & check whether all the required objects are collected into transport request.
4. Unit test the changes in BPD and confirm the results.
5. Transport the changes to BPQ for further testing.
Issues
None